---
title: Overview
---

Querying file(s) stored in an external object store like S3 is as simple as passing a `scheme://path/to/file` string to the `files` option of
`CREATE FOREIGN TABLE`. A few examples include:

### Amazon S3

```sql
CREATE FOREIGN TABLE parquet_table ()
SERVER parquet_server
OPTIONS (files 's3://<bucket>/<path>/<file>.parquet');
```

### Azure

```sql
CREATE FOREIGN TABLE parquet_table ()
SERVER parquet_server
OPTIONS (files 'az://<bucket>/<path>/<file>.parquet');
```

### Cloudflare R2

```sql
CREATE FOREIGN TABLE parquet_table ()
SERVER parquet_server
OPTIONS (files 'r2://<bucket>/<path>/<file>.parquet');
```

### Google Cloud Storage

```sql
CREATE FOREIGN TABLE parquet_table ()
SERVER parquet_server
OPTIONS (files 'gs://<container>/<path>/<file>.parquet');
```

### HTTP Server

```sql
CREATE FOREIGN TABLE parquet_table ()
SERVER parquet_server
OPTIONS (files 'https://<domain>/<path>/<file>.parquet');
```

### Hugging Face

```sql
CREATE FOREIGN TABLE csv_table ()
SERVER csv_server
OPTIONS (files 'hf://datasets/datasets-examples/doc-formats-csv-1/data.csv');
```

Credentials, endpoints, and other parameters can be specified with the `CREATE USER MAPPING` command. Please see the appropriate
object store documentation for details.
